<!--
File Name 	: 	attendManagerExcel.jsp
기능			:	액셀 다운로드
-->
<%@ page 	language="java" 	contentType="application/vnd.ms-excel; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page 	import="java.util.Date"%>
<%@ taglib 	prefix="s" 			uri="/struts-tags"%>
<%
	response.setHeader("Content-Disposition", "attachment; filename=PHILERGYSYSTEM_"+ new SimpleDateFormat("yyyyMMddHHmm").format(new Date()) +"_excel.xls"); 
    response.setHeader("Content-Description", "JSP Generated Data"); 

	//[출처] 간단하게 JSP로 Excel파일 생성하기(excel,엑셀) - 자바누리|작성자 비온디
 %>

<%@page import="java.text.SimpleDateFormat"%>
<html>
<!-- ============================== BODY START ==============================-->
<head>
	<meta http-equiv="Content-Type" 	content="text/html; charset=UTF-8" />
	<meta http-equiv="pragma" 			content="no-cache" />
	<meta http-equiv="cache-control" 	content="no-cache" />
	<meta http-equiv="expires" 			content="0" />
	<title>근태관리확인-관리자</title>
	
	<!-- ============================== J A V A S C R I P T		S T  A R T ============================== -->
	<script type="text/javascript">
		<!--
		//-->
	</script>
</head>
<!-- ============================== BODY START ============================== -->
<body>

	<table border="1">
		<tr>
			<th>그룹</th>
			<th>팀</th>
			<th>성명</th>
			<th>기준일짜</th>
			<th>요일</th>
			<th>출/퇴근 유형</th>
			<th>출/퇴근 날짜</th>
			<th>출/퇴근 시간</th>
			<th>등록 IP</th>
			<th>출/퇴근 유형</th>
			<th>출/퇴근지</th>
			<th>입력자 비고</th>
			<th>휴가반영 일수</th>
			<th>확인시간</th>
			<th>확인자 비고</th>
			<th>확인자</th>
		</tr>
		<s:iterator value="list">		
		<tr>
			<td><s:property value="group_nm_tt"/></td>
			<td><s:property value="team_nm"/></td>
			<td><s:property value="emp_nm"/></td>
			<td><s:property value="yyyymmdd"/></td>
			<td><s:property value="dayname"/></td>
			<td><s:property value="in_out_tp_nm"/></td>
			<td><s:property value="in_out_dt"/></td>
			<td><s:property value="in_out_time"/></td>
			<td><s:property value="reg_ip"/></td>
			<td><s:property value="in_out_detail_nm"/></td>
			<td><s:property value="in_out_place_nm"/></td>
			<td><s:property value="etc_emp"/></td>
			<td><s:property value="advantage_nm"/></td>
			<td><s:property value="update_dt"/></td>
			<td><s:property value="etc_mgr"/></td>
			<td><s:property value="approv_emp_nm_tt"/></td>
		</tr>
		</s:iterator>
	</table>
</body>
<!-- ============================== BODY END ============================== -->

</html>